package com.eies.workflow.util;


import ctais.services.data.DataWindow;
import ctais.util.StringEx;

public class DmmcUtil
{
	 public static String setIrregularDmTranslate(String tableName,String argDmValue,String dmColName,String mcColName)throws Exception
	 {
		 String sqlString="SELECT  "+mcColName+" FROM "+tableName+" WHERE "+dmColName+"='"+argDmValue+"'";
		 DataWindow dataWindow=DataWindow.dynamicCreate(sqlString);
		 if(dataWindow.retrieve()<=0) return "";
		 String rtn=StringEx.sNull(dataWindow.getItemAny(0, mcColName));
		  return rtn;
	 }
}
